Visual Basic Applications and Spreadsheet for Teaching Estimation of Nonparametric Density and Regression Functions
نویسنده
چکیده
The aim of this paper is to show how teachers can use Visual Basic language on the spreadsheet for student sin order to gain the skills need in using nonparametric techniques for density and regression function estimations. The author has built a useful didactic tool on Excel Visual Basic for teaching and practice of nonparametric kernel methods, being intended for students with some preliminary knowledge on this topic. This Visual Basic Application (VBA) is loaded into Excel as a MACRO (or into the modules of a Workbook for EXCEL). The specific user functions incorporated into it are easy tools for students to obtain an intuitive perception of nonparametric estimation for density and regression functions. The VBA also allows Excel to make use of an added menu similar to a small Statistical Package specialised in nonparametric methods.
منابع مشابه
Using Spreadsheets and VBA for Teaching Civil Engineering Concepts
Spreadsheets are becoming increasingly popular in solving engineering related problems. Among the strong features of spreadsheets are their instinctive cell-based structure and easy to use capabilities. Excel, for example, is a powerful spreadsheet with VBA robust programming capabilities that can be a powerful tool for teaching civil engineering concepts. Spreadsheets can do basic calculations...
متن کاملA New Nonparametric Regression for Longitudinal Data
In many area of medical research, a relation analysis between one response variable and some explanatory variables is desirable. Regression is the most common tool in this situation. If we have some assumptions for such normality for response variable, we could use it. In this paper we propose a nonparametric regression that does not have normality assumption for response variable and we focus ...
متن کاملA Berry-Esseen Type Bound for a Smoothed Version of Grenander Estimator
In various statistical model, such as density estimation and estimation of regression curves or hazard rates, monotonicity constraints can arise naturally. A frequently encountered problem in nonparametric statistics is to estimate a monotone density function f on a compact interval. A known estimator for density function of f under the restriction that f is decreasing, is Grenander estimator, ...
متن کاملStatistical Topology Using the Nonparametric Density Estimation and Bootstrap Algorithm
This paper presents approximate confidence intervals for each function of parameters in a Banach space based on a bootstrap algorithm. We apply kernel density approach to estimate the persistence landscape. In addition, we evaluate the quality distribution function estimator of random variables using integrated mean square error (IMSE). The results of simulation studies show a significant impro...
متن کاملA MODIFICATION ON RIDGE ESTIMATION FOR FUZZY NONPARAMETRIC REGRESSION
This paper deals with ridge estimation of fuzzy nonparametric regression models using triangular fuzzy numbers. This estimation method is obtained by implementing ridge regression learning algorithm in the La- grangian dual space. The distance measure for fuzzy numbers that suggested by Diamond is used and the local linear smoothing technique with the cross- validation procedure for selecting t...
متن کامل